/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : oyk

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 15/04/2021 14:57:25
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bew_admin_config
-- ----------------------------
DROP TABLE IF EXISTS `bew_admin_config`;
CREATE TABLE `bew_admin_config` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '系统设置ID',
  `config_name` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '功能名，代码参照使用',
  `config_info` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '中文名',
  `config_type` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '类型 1文本 2图片 3富文本',
  `config_value` text CHARACTER SET utf8 COMMENT '值',
  `config_desc` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '描述',
  `config_sort` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `config_status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1启用 0禁用',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='配置表';

-- ----------------------------
-- Records of bew_admin_config
-- ----------------------------
BEGIN;
INSERT INTO `bew_admin_config` VALUES (1, 'admin_domain', '本地域名', 1, 'http://www.ouyangke.com', '项目域名', 0, 1);
INSERT INTO `bew_admin_config` VALUES (2, 'admin_route', '项目路径', 1, '/index.php/bews/', '后台项目路径', 0, 1);
INSERT INTO `bew_admin_config` VALUES (3, 'admin_name', '系统名称', 1, 'layui new  admin后台管理', '后台系统名称，在后台显示', 0, 1);
INSERT INTO `bew_admin_config` VALUES (4, 'admin_page', '每页数量', 1, '10', '列表数据，每页数量', 0, 1);
INSERT INTO `bew_admin_config` VALUES (5, 'logo', 'logo', 2, '/static/bews/images/logo2.png', '请上传logo', 0, 1);
INSERT INTO `bew_admin_config` VALUES (6, 'admin_info', '系统介绍', 3, '', '系统介绍', 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for bew_admin_sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `bew_admin_sys_menu`;
CREATE TABLE `bew_admin_sys_menu` (
  `smid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `label` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '菜单类型，0：分组标签，1：C链接，2：超链接',
  `src` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '链接源',
  `parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上级菜单ID',
  `icon_class` varchar(100) CHARACTER SET utf8 DEFAULT NULL COMMENT '图标class',
  `icon_color` varchar(7) DEFAULT NULL COMMENT '图标颜色#000000',
  `sort` mediumint(6) unsigned NOT NULL DEFAULT '1' COMMENT '排序值，升序',
  `remark` varchar(128) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 0关闭',
  PRIMARY KEY (`smid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7007 DEFAULT CHARSET=utf8mb4 COMMENT='左侧菜单';

-- ----------------------------
-- Records of bew_admin_sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `bew_admin_sys_menu` VALUES (1, '项目核心', 0, '', 0, 'layui-icon-template-1', '', 999999, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (2, '导航管理', 1, 'bew/menuinfo', 1, 'layui-icon-layer', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (3, '项目配置', 1, 'bew/configvalue', 1, 'layui-icon-set-fill', '', 100, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (5000, '系统配置', 0, '', 0, 'layui-icon-set', '', 999996, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (5002, '部门管理', 1, 'bewadmin/groupinfo', 5000, 'layui-icon-group', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (5003, '管理员管理', 1, 'bewadmin/userinfo', 5000, 'layui-icon-username', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (5004, '个人中心', 1, 'bewadmin/admininfo', 5000, 'layui-icon-edit', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7000, '代码示例', 0, '', 0, 'layui-icon-app', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7001, '图标', 1, 'bewtest/icon_list', 7000, 'layui-icon-theme', '', 1, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7002, '报名系统', 1, NULL, 0, '', '#666666', 0, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7003, '用户列表', 1, 'oyk/user_list', 7002, '', '#666666', 0, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7004, '班级列表', 1, 'oyk/class_list', 7002, '', '#666666', 0, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7005, '广告列表', 1, 'oyk/ad_list', 7002, '', '#666666', 0, '', 1);
INSERT INTO `bew_admin_sys_menu` VALUES (7006, '学校列表', 1, 'oyk/school_list', 7002, '', '#666666', 0, '', 1);
COMMIT;

-- ----------------------------
-- Table structure for bew_admin_user
-- ----------------------------
DROP TABLE IF EXISTS `bew_admin_user`;
CREATE TABLE `bew_admin_user` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `account` varchar(64) CHARACTER SET utf8 NOT NULL COMMENT '账号邮箱',
  `password` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '密码',
  `name` varchar(32) CHARACTER SET utf8 DEFAULT NULL COMMENT '姓名',
  `mobile` varchar(18) CHARACTER SET utf8 DEFAULT NULL COMMENT '手机号',
  `qq` varchar(16) CHARACTER SET utf8 DEFAULT NULL COMMENT 'QQ号',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别 0未知 1男 2女',
  `group_id` int(10) unsigned NOT NULL COMMENT '分组ID',
  `times_login` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登陆次数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 0禁用',
  `time_add` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `time_last` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后更新时间',
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE KEY `one_account` (`account`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户信息表';

-- ----------------------------
-- Records of bew_admin_user
-- ----------------------------
BEGIN;
INSERT INTO `bew_admin_user` VALUES (1, '428188207@qq.com', 'e10adc3949ba59abbe56e057f20f883e', '欧阳克', '0', '428188207', 1, 1, 263, 1, 1564124524, 1618388754);
COMMIT;

-- ----------------------------
-- Table structure for bew_admin_user_group
-- ----------------------------
DROP TABLE IF EXISTS `bew_admin_user_group`;
CREATE TABLE `bew_admin_user_group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(32) CHARACTER SET utf8 NOT NULL COMMENT '部门名',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否生效',
  `time_add` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `rights` text CHARACTER SET utf8 COMMENT '角色权限，json',
  PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='组管理';

-- ----------------------------
-- Records of bew_admin_user_group
-- ----------------------------
BEGIN;
INSERT INTO `bew_admin_user_group` VALUES (1, '管理', 1, 1564124524, '[1,2,3,5000,5002,5003,5004,7000,7001,7002,7003,7004,7005,7006]');
COMMIT;

-- ----------------------------
-- Table structure for bew_z_iconfont
-- ----------------------------
DROP TABLE IF EXISTS `bew_z_iconfont`;
CREATE TABLE `bew_z_iconfont` (
  `icon_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '图标ID',
  `icon_name` varchar(50) DEFAULT NULL COMMENT '图标名称',
  `icon_css` varchar(100) DEFAULT NULL COMMENT '图标css',
  `icon_html` varchar(100) DEFAULT NULL COMMENT '图标html',
  `icon_source` tinyint(1) unsigned DEFAULT '1' COMMENT '来源 1layui',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 0关闭',
  PRIMARY KEY (`icon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8mb4 COMMENT='图标库';

-- ----------------------------
-- Records of bew_z_iconfont
-- ----------------------------
BEGIN;
INSERT INTO `bew_z_iconfont` VALUES (1, '实心', 'layui-icon-heart-fill', '&#xe68f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (2, '空心', 'layui-icon-heart', '&#xe68c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (3, '亮度/晴', 'layui-icon-light', '&#xe748;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (4, '时间/历史', 'layui-icon-time', '&#xe68d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (5, '蓝牙', 'layui-icon-bluetooth', '&#xe689;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (6, '@艾特', 'layui-icon-at', '&#xe687;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (7, '静音', 'layui-icon-mute', '&#xe685;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (8, '录音/麦克风', 'layui-icon-mike', '&#xe6dc;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (9, '密钥/钥匙', 'layui-icon-key', '&#xe683;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (10, '礼物/活动', 'layui-icon-gift', '&#xe627;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (11, '邮箱', 'layui-icon-email', '&#xe618;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (12, 'RSS', 'layui-icon-rss', '&#xe808;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (13, 'WiFi', 'layui-icon-wifi', '&#xe7e0;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (14, '退出/注销', 'layui-icon-logout', '&#xe682;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (15, 'Android 安卓', 'layui-icon-android', '&#xe684;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (16, 'Apple IOS 苹果', 'layui-icon-ios', '&#xe680;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (17, 'Windows', 'layui-icon-windows', '&#xe67f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (18, '穿梭框', 'layui-icon-transfer', '&#xe691;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (19, '客服', 'layui-icon-service', '&#xe626;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (20, '减', 'layui-icon-subtraction', '&#xe67e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (21, '加', 'layui-icon-addition', '&#xe624;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (22, '滑块', 'layui-icon-slider', '&#xe714;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (23, '打印', 'layui-icon-print', '&#xe66d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (24, '导出', 'layui-icon-export', '&#xe67d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (25, '列', 'layui-icon-cols', '&#xe610;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (26, '退出全屏', 'layui-icon-screen-restore', '&#xe758;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (27, '全屏', 'layui-icon-screen-full', '&#xe622;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (28, '半星', 'layui-icon-rate-half', '&#xe6c9;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (29, '星星-空心', 'layui-icon-rate', '&#xe67b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (30, '星星-实心', 'layui-icon-rate-solid', '&#xe67a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (31, '手机', 'layui-icon-cellphone', '&#xe678;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (32, '验证码', 'layui-icon-vercode', '&#xe679;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (33, '微信', 'layui-icon-login-wechat', '&#xe677;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (34, 'QQ', 'layui-icon-login-qq', '&#xe676;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (35, '微博', 'layui-icon-login-weibo', '&#xe675;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (36, '密码', 'layui-icon-password', '&#xe673;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (37, '用户名', 'layui-icon-username', '&#xe66f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (38, '刷新-粗', 'layui-icon-refresh-3', '&#xe9aa;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (39, '授权', 'layui-icon-auz', '&#xe672;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (40, '左向右伸缩菜单', 'layui-icon-spread-left', '&#xe66b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (41, '右向左伸缩菜单', 'layui-icon-shrink-right', '&#xe668;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (42, '雪花', 'layui-icon-snowflake', '&#xe6b1;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (43, '提示说明', 'layui-icon-tips', '&#xe702;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (44, '便签', 'layui-icon-note', '&#xe66e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (45, '主页', 'layui-icon-home', '&#xe68e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (46, '高级', 'layui-icon-senior', '&#xe674;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (47, '刷新', 'layui-icon-refresh', '&#xe669;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (48, '刷新', 'layui-icon-refresh-1', '&#xe666;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (49, '旗帜', 'layui-icon-flag', '&#xe66c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (50, '主题', 'layui-icon-theme', '&#xe66a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (51, '消息-通知', 'layui-icon-notice', '&#xe667;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (52, '网站', 'layui-icon-website', '&#xe7ae;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (53, '控制台', 'layui-icon-console', '&#xe665;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (54, '表情-惊讶', 'layui-icon-face-surprised', '&#xe664;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (55, '设置-空心', 'layui-icon-set', '&#xe716;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (56, '模板', 'layui-icon-template-1', '&#xe656;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (57, '应用', 'layui-icon-app', '&#xe653;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (58, '模板', 'layui-icon-template', '&#xe663;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (59, '赞', 'layui-icon-praise', '&#xe6c6;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (60, '踩', 'layui-icon-tread', '&#xe6c5;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (61, '男', 'layui-icon-male', '&#xe662;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (62, '女', 'layui-icon-female', '&#xe661;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (63, '相机-空心', 'layui-icon-camera', '&#xe660;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (64, '相机-实心', 'layui-icon-camera-fill', '&#xe65d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (65, '菜单-水平', 'layui-icon-more', '&#xe65f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (66, '菜单-垂直', 'layui-icon-more-vertical', '&#xe671;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (67, '金额-人民币', 'layui-icon-rmb', '&#xe65e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (68, '金额-美元', 'layui-icon-dollar', '&#xe659;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (69, '钻石-等级', 'layui-icon-diamond', '&#xe735;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (70, '火', 'layui-icon-fire', '&#xe756;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (71, '返回', 'layui-icon-return', '&#xe65c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (72, '位置-地图', 'layui-icon-location', '&#xe715;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (73, '办公-阅读', 'layui-icon-read', '&#xe705;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (74, '调查', 'layui-icon-survey', '&#xe6b2;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (75, '表情-微笑', 'layui-icon-face-smile', '&#xe6af;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (76, '表情-哭泣', 'layui-icon-face-cry', '&#xe69c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (77, '购物车', 'layui-icon-cart-simple', '&#xe698;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (78, '购物车', 'layui-icon-cart', '&#xe657;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (79, '下一页', 'layui-icon-next', '&#xe65b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (80, '上一页', 'layui-icon-prev', '&#xe65a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (81, '上传-空心-拖拽', 'layui-icon-upload-drag', '&#xe681;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (82, '上传-实心', 'layui-icon-upload', '&#xe67c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (83, '下载-圆圈', 'layui-icon-download-circle', '&#xe601;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (84, '组件', 'layui-icon-component', '&#xe857;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (85, '文件-粗', 'layui-icon-file-b', '&#xe655;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (86, '用户', 'layui-icon-user', '&#xe770;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (87, '发现-实心', 'layui-icon-find-fill', '&#xe670;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (88, 'loading', 'layui-icon-loading', '&#xe63d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (89, 'loading', 'layui-icon-loading-1', '&#xe63e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (90, '添加', 'layui-icon-add-1', '&#xe654;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (91, '播放', 'layui-icon-play', '&#xe652;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (92, '暂停', 'layui-icon-pause', '&#xe651;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (93, '音频-耳机', 'layui-icon-headset', '&#xe6fc;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (94, '视频', 'layui-icon-video', '&#xe6ed;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (95, '语音-声音', 'layui-icon-voice', '&#xe688;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (96, '消息-通知-喇叭', 'layui-icon-speaker', '&#xe645;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (97, '删除线', 'layui-icon-fonts-del', '&#xe64f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (98, '代码', 'layui-icon-fonts-code', '&#xe64e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (99, 'HTML', 'layui-icon-fonts-html', '&#xe64b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (100, '字体加粗', 'layui-icon-fonts-strong', '&#xe62b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (101, '删除链接', 'layui-icon-unlink', '&#xe64d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (102, '图片', 'layui-icon-picture', '&#xe64a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (103, '链接', 'layui-icon-link', '&#xe64c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (104, '表情-笑-粗', 'layui-icon-face-smile-b', '&#xe650;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (105, '左对齐', 'layui-icon-align-left', '&#xe649;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (106, '右对齐', 'layui-icon-align-right', '&#xe648;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (107, '居中对齐', 'layui-icon-align-center', '&#xe647;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (108, '字体-下划线', 'layui-icon-fonts-u', '&#xe646;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (109, '字体-斜体', 'layui-icon-fonts-i', '&#xe644;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (110, 'Tabs 选项卡', 'layui-icon-tabs', '&#xe62a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (111, '单选框-选中', 'layui-icon-radio', '&#xe643;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (112, '单选框-候选', 'layui-icon-circle', '&#xe63f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (113, '编辑', 'layui-icon-edit', '&#xe642;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (114, '分享', 'layui-icon-share', '&#xe641;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (115, '删除', 'layui-icon-delete', '&#xe640;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (116, '表单', 'layui-icon-form', '&#xe63c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (117, '手机-细体', 'layui-icon-cellphone-fine', '&#xe63b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (118, '聊天 对话 沟通', 'layui-icon-dialogue', '&#xe63a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (119, '文字格式化', 'layui-icon-fonts-clear', '&#xe639;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (120, '窗口', 'layui-icon-layer', '&#xe638;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (121, '日期', 'layui-icon-date', '&#xe637;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (122, '水 下雨', 'layui-icon-water', '&#xe636;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (123, '代码-圆圈', 'layui-icon-code-circle', '&#xe635;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (124, '轮播组图', 'layui-icon-carousel', '&#xe634;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (125, '翻页', 'layui-icon-prev-circle', '&#xe633;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (126, '布局', 'layui-icon-layouts', '&#xe632;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (127, '工具', 'layui-icon-util', '&#xe631;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (128, '选择模板', 'layui-icon-templeate-1', '&#xe630;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (129, '上传-圆圈', 'layui-icon-upload-circle', '&#xe62f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (130, '树', 'layui-icon-tree', '&#xe62e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (131, '表格', 'layui-icon-table', '&#xe62d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (132, '图表', 'layui-icon-chart', '&#xe62c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (133, '图标 报表 屏幕', 'layui-icon-chart-screen', '&#xe629;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (134, '引擎', 'layui-icon-engine', '&#xe628;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (135, '下三角', 'layui-icon-triangle-d', '&#xe625;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (136, '右三角', 'layui-icon-triangle-r', '&#xe623;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (137, '文件', 'layui-icon-file', '&#xe621;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (138, '设置-小型', 'layui-icon-set-sm', '&#xe620;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (139, '减少-圆圈', 'layui-icon-reduce-circle', '&#xe616', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (140, '添加-圆圈', 'layui-icon-add-circle', '&#xe61f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (141, '404', 'layui-icon-404', '&#xe61c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (142, '关于', 'layui-icon-about', '&#xe60b;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (143, '箭头 向上', 'layui-icon-up', '&#xe619;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (144, '箭头 向下', 'layui-icon-down', '&#xe61a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (145, '箭头 向左', 'layui-icon-left', '&#xe603;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (146, '箭头 向右', 'layui-icon-right', '&#xe602;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (147, '圆点', 'layui-icon-circle-dot', '&#xe617;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (148, '搜索', 'layui-icon-search', '&#xe615;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (149, '设置-实心', 'layui-icon-set-fill', '&#xe614;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (150, '群组', 'layui-icon-group', '&#xe613;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (151, '好友', 'layui-icon-friends', '&#xe612;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (152, '回复 评论 实心', 'layui-icon-reply-fill', '&#xe611;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (153, '菜单 隐身 实心', 'layui-icon-menu-fill', '&#xe60f;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (154, '记录', 'layui-icon-log', '&#xe60e;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (155, '图片-细体', 'layui-icon-picture-fine', '&#xe60d;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (156, '表情-笑-细体', 'layui-icon-face-smile-fine', '&#xe60c;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (157, '列表', 'layui-icon-list', '&#xe60a;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (158, '发布 纸飞机', 'layui-icon-release', '&#xe609;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (159, '对 OK', 'layui-icon-ok', '&#xe605;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (160, '帮助', 'layui-icon-help', '&#xe607;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (161, '客服', 'layui-icon-chat', '&#xe606;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (162, 'top 置顶', 'layui-icon-top', '&#xe604;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (163, '收藏-空心', 'layui-icon-star', '&#xe600;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (164, '收藏-实心', 'layui-icon-star-fill', '&#xe658;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (165, '关闭-实心', 'layui-icon-close-fill', '&#x1007;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (166, '关闭-空心', 'layui-icon-close', '&#x1006;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (167, '正确', 'layui-icon-ok-circle', '&#x1005;', 1, 1);
INSERT INTO `bew_z_iconfont` VALUES (168, '添加-圆圈-细体', 'layui-icon-add-circle-fine', '&#xe608;', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for oyk_ad
-- ----------------------------
DROP TABLE IF EXISTS `oyk_ad`;
CREATE TABLE `oyk_ad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '广告ID',
  `title` varchar(200) DEFAULT NULL COMMENT '标题',
  `img` varchar(200) DEFAULT NULL COMMENT '图片',
  `url` varchar(200) DEFAULT NULL COMMENT '跳转url',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态 1开启 0关闭',
  `sort` int(10) unsigned DEFAULT '0' COMMENT '排序',
  `position` tinyint(1) unsigned DEFAULT '1' COMMENT '位置 1首页广告',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='广告图';

-- ----------------------------
-- Records of oyk_ad
-- ----------------------------
BEGIN;
INSERT INTO `oyk_ad` VALUES (1, '广告1', '/storage/bews/20210412/083d67f578d9bd7f7ba59c2b8b3b35c3.jpg', 'http://www.php.cn', 1, 10, 1);
INSERT INTO `oyk_ad` VALUES (2, '广告2', '/storage/bews/20210412/2fe5ecf402629595536d6262271456e7.jpg', 'http://www.php.cn', 1, 10, 1);
COMMIT;

-- ----------------------------
-- Table structure for oyk_school
-- ----------------------------
DROP TABLE IF EXISTS `oyk_school`;
CREATE TABLE `oyk_school` (
  `school_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '学校ID',
  `school_name` varchar(200) NOT NULL COMMENT '学校名字',
  `name` varchar(200) NOT NULL COMMENT '负责人',
  `phone` varchar(20) NOT NULL COMMENT '电话',
  `license` varchar(200) NOT NULL COMMENT '证件',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2待审核 0关闭 9删除',
  PRIMARY KEY (`school_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='学校、教学点、老师';

-- ----------------------------
-- Records of oyk_school
-- ----------------------------
BEGIN;
INSERT INTO `oyk_school` VALUES (1, 'PHP中文网', '天蓬', '18811119999', '/storage/bews/20210412/b685a468b1fe5080b808320d77adb99c.jpg', 3, 1618206680, 1);
INSERT INTO `oyk_school` VALUES (2, 'PHP英文网', '欧阳克', '18822223333', '/storage/bews/20210412/9fd03ec49657c03499068a4e0ac600ae.jpg', 2, 1618206680, 1);
INSERT INTO `oyk_school` VALUES (3, 'PHP英文网', '西门大官人', '18933334444', '/storage/bews/20210412/300ec66dc0322fd5c4074a2c30f39d6b.png', 4, 1618210602, 1);
COMMIT;

-- ----------------------------
-- Table structure for oyk_school_class
-- ----------------------------
DROP TABLE IF EXISTS `oyk_school_class`;
CREATE TABLE `oyk_school_class` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '班级ID',
  `title` varchar(200) NOT NULL COMMENT '标题或班级名称',
  `school_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学校ID',
  `address` varchar(300) NOT NULL COMMENT '上课地址',
  `tuition` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '学费',
  `people_num` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '招收人数',
  `teacher_img` varchar(200) DEFAULT NULL COMMENT '老师头像',
  `teacher_name` varchar(200) NOT NULL COMMENT '老师名字',
  `teacher_phone` varchar(200) NOT NULL COMMENT '老师电话',
  `class_start_date` date NOT NULL COMMENT '开始上课日期',
  `class_time` varchar(200) NOT NULL COMMENT '上课周期',
  `class_hour` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '课时',
  `class_end_date` date NOT NULL COMMENT '报名截止时间',
  `intr` text COMMENT '课程介绍',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `edit_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1开启 2待审核 0关闭 9删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='班级';

-- ----------------------------
-- Records of oyk_school_class
-- ----------------------------
BEGIN;
INSERT INTO `oyk_school_class` VALUES (1, '标题1', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-05', '周一 19点-21点', 36, '2021-04-10', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (2, '标题2', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (3, '标题3', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (4, '标题4', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (5, '标题5', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (6, '标题6', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (7, '标题7', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (8, '标题8', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (9, '标题9', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (10, '标题0', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (11, '标题11', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (12, '标题12', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (13, '标题13', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (14, '标题14', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (15, '标题15', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (16, '标题16', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (17, '标题17', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (18, '标题18', 1, '	302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (19, '标题20', 1, '302室', 288, 40, NULL, '灭绝师太', '18811112222', '2021-04-18', '周一 19点-21点', 24, '2021-04-18', '/storage/bews/20210412/bbce87cfe0eb538834ff21eb7ba5f8eb.png;/storage/bews/20210412/67bafb33d413aec3dd3d19739a70e04d.jpg;/storage/bews/20210412/d58f9b9b227fc3ed339e5b442a708b52.jpg;/storage/bews/20210412/4510b08dccb648a90848eaedd54d29fd.png', 1617866531, 0, 1);
INSERT INTO `oyk_school_class` VALUES (20, '报名系统公益课', 2, 'php中文网2室', 0, 1000, '/storage/bews/20210414/36b52426ee483ebeab3ca5af63f8d0d0.jpg', '欧阳克', '18811112222', '2021-04-12', '20点-22点', 20, '2021-04-16', NULL, 1618466071, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for oyk_user
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user`;
CREATE TABLE `oyk_user` (
  `uid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `unionid` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT '微信用户唯一识别码',
  `openid` varchar(100) CHARACTER SET utf8 DEFAULT '' COMMENT '微信用户唯一识别码',
  `phone` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机号',
  `nickname` varchar(50) NOT NULL DEFAULT '' COMMENT '昵称',
  `pwd` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '密码',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '1为正常，0为禁止',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '注册时间',
  `last_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `avatar` varchar(200) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '头像',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别，值为1时是男性，值为2时是女性，值为0时是未知',
  `is_teacher` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '老师 1是 0否',
  PRIMARY KEY (`uid`) USING BTREE,
  KEY `add_time` (`add_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of oyk_user
-- ----------------------------
BEGIN;
INSERT INTO `oyk_user` VALUES (2, '', '', '18711112222', '欧阳克', 'e10adc3949ba59abbe56e057f20f883e', 1, 1617852752, 1617852752, '', 1, 0);
INSERT INTO `oyk_user` VALUES (3, '', '', '18711113333', '西门大官人', 'e10adc3949ba59abbe56e057f20f883e', 1, 1617932335, 1617932335, '', 0, 0);
INSERT INTO `oyk_user` VALUES (4, '', '', '15311112222', 'bmxt20210410004716291', 'e10adc3949ba59abbe56e057f20f883e', 1, 1617986836, 1617986836, '', 0, 0);
INSERT INTO `oyk_user` VALUES (5, '', '', '15311113333', 'bmxt20210410004805555', 'e10adc3949ba59abbe56e057f20f883e', 1, 1617986885, 1617986885, '', 0, 0);
INSERT INTO `oyk_user` VALUES (6, '', '', '15311114444', 'bmxt20210410010948532', 'e10adc3949ba59abbe56e057f20f883e', 1, 1617988188, 1617988188, '', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for oyk_user_enroll
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user_enroll`;
CREATE TABLE `oyk_user_enroll` (
  `enroll_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '班级ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid',
  `baby_name` varchar(50) NOT NULL COMMENT '孩子名字',
  `baby_gender` tinyint(1) unsigned DEFAULT '1' COMMENT '孩子姓名 1男 2女',
  `baby_age` int(3) unsigned DEFAULT '0' COMMENT '年龄',
  `baby_school` varchar(200) NOT NULL COMMENT '孩子学校名',
  `baby_grade` varchar(200) NOT NULL COMMENT '年级',
  `baby_class` varchar(200) NOT NULL COMMENT '班级',
  `parent_name` varchar(50) NOT NULL COMMENT '家长姓名',
  `parent_phone` varchar(50) NOT NULL COMMENT '家长电话',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态 1已报名 2取消报名 9老师取消报名',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '报名时间',
  PRIMARY KEY (`enroll_id`) USING BTREE,
  KEY `add_time` (`add_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户报名';

-- ----------------------------
-- Records of oyk_user_enroll
-- ----------------------------
BEGIN;
INSERT INTO `oyk_user_enroll` VALUES (1, 2, 2, '西门小小官人', 1, 0, '合肥青年路小学', '', '一3班', '西门大官人', '18811113333', 2, 1617935869);
INSERT INTO `oyk_user_enroll` VALUES (2, 2, 2, '西门小官人', 1, 6, '合肥青年路小学', '一年级', '2班', '西门大官人', '18811113333', 1, 1618133168);
COMMIT;

-- ----------------------------
-- Table structure for oyk_user_name
-- ----------------------------
DROP TABLE IF EXISTS `oyk_user_name`;
CREATE TABLE `oyk_user_name` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户uid',
  `baby_name` varchar(50) NOT NULL COMMENT '孩子名字',
  `baby_gender` tinyint(1) unsigned DEFAULT '1' COMMENT '孩子姓名 1男 2女',
  `baby_age` int(3) unsigned DEFAULT '0' COMMENT '年龄',
  `baby_school` varchar(200) NOT NULL COMMENT '孩子学校名',
  `baby_grade` varchar(200) NOT NULL COMMENT '年级',
  `baby_class` varchar(200) NOT NULL COMMENT '班级',
  `parent_name` varchar(50) NOT NULL COMMENT '家长姓名',
  `parent_phone` varchar(50) NOT NULL COMMENT '家长电话',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='用户孩子名单';

-- ----------------------------
-- Records of oyk_user_name
-- ----------------------------
BEGIN;
INSERT INTO `oyk_user_name` VALUES (1, 2, '西门小小官人', 1, 0, '合肥青年路小学', '', '一3班', '西门大官人', '18811113333');
INSERT INTO `oyk_user_name` VALUES (2, 2, '西门小官人', 1, 7, '合肥青年路小学', '一年级', '2班', '西门大官人', '18811113333');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
